Pandas Profiling Report

Dataset statistics

Number of variables	20
Number of observations	21608
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	3.5 MiB
Average record size in memory	168.0 B

Variable types

Numeric	17
Categorical	3

Alerts

`age` is highly overall correlated with `bathrooms` and 3 other fields	High correlation
`bathrooms` is highly overall correlated with `age` and 7 other fields	High correlation
`bedrooms` is highly overall correlated with `bathrooms` and 2 other fields	High correlation
`floors` is highly overall correlated with `age` and 4 other fields	High correlation
`grade` is highly overall correlated with `age` and 7 other fields	High correlation
`price` is highly overall correlated with `grade` and 3 other fields	High correlation
`renovation_age` is highly overall correlated with `yr_renovated`	High correlation
`sqft_above` is highly overall correlated with `bathrooms` and 6 other fields	High correlation
`sqft_living` is highly overall correlated with `bathrooms` and 5 other fields	High correlation
`sqft_living15` is highly overall correlated with `bathrooms` and 4 other fields	High correlation
`sqft_lot` is highly overall correlated with `sqft_lot15`	High correlation
`sqft_lot15` is highly overall correlated with `sqft_lot`	High correlation
`view` is highly overall correlated with `waterfront`	High correlation
`waterfront` is highly overall correlated with `view`	High correlation
`yr_built` is highly overall correlated with `age` and 3 other fields	High correlation
`yr_renovated` is highly overall correlated with `renovation_age`	High correlation
`waterfront` is highly imbalanced (93.6%)	Imbalance
`view` is highly imbalanced (72.3%)	Imbalance
`sqft_basement` has 13123 (60.7%) zeros	Zeros
`yr_renovated` has 20695 (95.8%) zeros	Zeros

Reproduction

Analysis started	2023-11-23 07:58:45.790654
Analysis finished	2023-11-23 08:00:36.613368
Duration	1 minute and 50.82 seconds
Software version	ydata-profiling vv4.6.2
Download configuration	config.json

price
Real number (ℝ)

HIGH CORRELATION

Distinct	4028
Distinct (%)	18.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	540098.37

Minimum	75000
Maximum	7700000
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	337.6 KiB

Quantile statistics

Minimum	75000
5-th percentile	210000
Q1	321837.5
median	450000
Q3	645000
95-th percentile	1156780
Maximum	7700000
Range	7625000
Interquartile range (IQR)	323162.5

Descriptive statistics

Standard deviation	367164.57
Coefficient of variation (CV)	0.67981055
Kurtosis	34.578471
Mean	540098.37
Median Absolute Deviation (MAD)	150000
Skewness	4.0237083
Sum	1.1670446 × 10¹⁰
Variance	1.3480982 × 10¹¹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
350000	172	0.8%
450000	172	0.8%
550000	158	0.7%
500000	152	0.7%
425000	150	0.7%
325000	148	0.7%
400000	145	0.7%
375000	138	0.6%
300000	133	0.6%
525000	131	0.6%
Other values (4018)	20109	93.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
75000	1	< 0.1%
78000	1	< 0.1%
80000	1	< 0.1%
81000	1	< 0.1%
82000	1	< 0.1%
82500	1	< 0.1%
83000	1	< 0.1%
84000	1	< 0.1%
85000	2	< 0.1%
86500	1	< 0.1%

Value	Count	Frequency (%)
7700000	1	< 0.1%
7062500	1	< 0.1%
6885000	1	< 0.1%
5570000	1	< 0.1%
5350000	1	< 0.1%
5300000	1	< 0.1%
5110800	1	< 0.1%
4668000	1	< 0.1%
4500000	1	< 0.1%
4489000	1	< 0.1%

bedrooms
Real number (ℝ)

HIGH CORRELATION

Distinct	13
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	3.3709274

Minimum	0
Maximum	33
Zeros	13
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	337.6 KiB

Quantile statistics

Minimum	0
5-th percentile	2
Q1	3
median	3
Q3	4
95-th percentile	5
Maximum	33
Range	33
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.93010257
Coefficient of variation (CV)	0.27591889
Kurtosis	49.065621
Mean	3.3709274
Median Absolute Deviation (MAD)	1
Skewness	1.9743628
Sum	72839
Variance	0.86509079
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=13)

Value	Count	Frequency (%)
3	9821	45.5%
4	6881	31.8%
2	2759	12.8%
5	1601	7.4%
6	272	1.3%
1	199	0.9%
7	38	0.2%
0	13	0.1%
8	13	0.1%
9	6	< 0.1%
Other values (3)	5	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	13	0.1%
1	199	0.9%
2	2759	12.8%
3	9821	45.5%
4	6881	31.8%
5	1601	7.4%
6	272	1.3%
7	38	0.2%
8	13	0.1%
9	6	< 0.1%

Value	Count	Frequency (%)
33	1	< 0.1%
11	1	< 0.1%
10	3	< 0.1%
9	6	< 0.1%
8	13	0.1%
7	38	0.2%
6	272	1.3%
5	1601	7.4%
4	6881	31.8%
3	9821	45.5%

bathrooms
Real number (ℝ)

HIGH CORRELATION

Distinct	30
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2.1147376

Minimum	0
Maximum	8
Zeros	10
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	337.6 KiB

Quantile statistics

Minimum	0
5-th percentile	1
Q1	1.75
median	2.25
Q3	2.5
95-th percentile	3.5
Maximum	8
Range	8
Interquartile range (IQR)	0.75

Descriptive statistics

Standard deviation	0.7702384
Coefficient of variation (CV)	0.3642241
Kurtosis	1.2792646
Mean	2.1147376
Median Absolute Deviation (MAD)	0.5
Skewness	0.51114612
Sum	45695.25
Variance	0.5932672
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=30)

Value	Count	Frequency (%)
2.5	5378	24.9%
1	3852	17.8%
1.75	3047	14.1%
2.25	2046	9.5%
2	1929	8.9%
1.5	1446	6.7%
2.75	1185	5.5%
3	753	3.5%
3.5	731	3.4%
3.25	589	2.7%
Other values (20)	652	3.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	10	< 0.1%
0.5	4	< 0.1%
0.75	72	0.3%
1	3852	17.8%
1.25	9	< 0.1%
1.5	1446	6.7%
1.75	3047	14.1%
2	1929	8.9%
2.25	2046	9.5%
2.5	5378	24.9%

Value	Count	Frequency (%)
8	2	< 0.1%
7.75	1	< 0.1%
7.5	1	< 0.1%
6.75	2	< 0.1%
6.5	2	< 0.1%
6.25	2	< 0.1%
6	6	< 0.1%
5.75	4	< 0.1%
5.5	10	< 0.1%
5.25	13	0.1%

sqft_living
Real number (ℝ)

HIGH CORRELATION

Distinct	1038
Distinct (%)	4.8%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	2079.959

Minimum	290
Maximum	13540
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	337.6 KiB

Quantile statistics

Minimum	290
5-th percentile	940
Q1	1429.25
median	1910
Q3	2550
95-th percentile	3760
Maximum	13540
Range	13250
Interquartile range (IQR)	1120.75

Descriptive statistics

Standard deviation	918.5058
Coefficient of variation (CV)	0.44159804
Kurtosis	5.2422093
Mean	2079.959
Median Absolute Deviation (MAD)	541
Skewness	1.4714675
Sum	44943753
Variance	843652.91
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1300	138	0.6%
1400	135	0.6%
1440	133	0.6%
1800	129	0.6%
1660	129	0.6%
1010	129	0.6%
1820	128	0.6%
1480	125	0.6%
1720	125	0.6%
1540	124	0.6%
Other values (1028)	20313	94.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
290	1	< 0.1%
370	1	< 0.1%
380	1	< 0.1%
384	1	< 0.1%
390	2	< 0.1%
410	1	< 0.1%
420	2	< 0.1%
430	1	< 0.1%
440	1	< 0.1%
460	1	< 0.1%

Value	Count	Frequency (%)
13540	1	< 0.1%
12050	1	< 0.1%
10040	1	< 0.1%
9890	1	< 0.1%
9640	1	< 0.1%
9200	1	< 0.1%
8670	1	< 0.1%
8020	1	< 0.1%
8010	1	< 0.1%
8000	1	< 0.1%

sqft_lot
Real number (ℝ)

HIGH CORRELATION

Distinct	9782
Distinct (%)	45.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	15109.616

Minimum	520
Maximum	1651359
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	337.6 KiB

Quantile statistics

Minimum	520
5-th percentile	1801.7
Q1	5040
median	7620
Q3	10690.5
95-th percentile	43343.7
Maximum	1651359
Range	1650839
Interquartile range (IQR)	5650.5

Descriptive statistics

Standard deviation	41424.914
Coefficient of variation (CV)	2.7416258
Kurtosis	285.01868
Mean	15109.616
Median Absolute Deviation (MAD)	2620
Skewness	13.058691
Sum	3.2648859 × 10⁸
Variance	1.7160235 × 10⁹
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	358	1.7%
6000	290	1.3%
4000	251	1.2%
7200	220	1.0%
4800	120	0.6%
7500	119	0.6%
4500	114	0.5%
8400	111	0.5%
9600	109	0.5%
3600	103	0.5%
Other values (9772)	19813	91.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
520	1	< 0.1%
572	1	< 0.1%
600	1	< 0.1%
609	1	< 0.1%
635	1	< 0.1%
638	1	< 0.1%
649	1	< 0.1%
651	1	< 0.1%
675	1	< 0.1%
676	1	< 0.1%

Value	Count	Frequency (%)
1651359	1	< 0.1%
1164794	1	< 0.1%
1074218	1	< 0.1%
1024068	1	< 0.1%
982998	1	< 0.1%
982278	1	< 0.1%
920423	1	< 0.1%
881654	1	< 0.1%
871200	2	< 0.1%
843309	1	< 0.1%

floors
Real number (ℝ)

HIGH CORRELATION

Distinct	6
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1.4941457

Minimum	1
Maximum	3.5
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	337.6 KiB

Quantile statistics

Minimum	1
5-th percentile	1
Q1	1
median	1.5
Q3	2
95-th percentile	2
Maximum	3.5
Range	2.5
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	0.53991035
Coefficient of variation (CV)	0.36135054
Kurtosis	-0.48487366
Mean	1.4941457
Median Absolute Deviation (MAD)	0.5
Skewness	0.61633974
Sum	32285.5
Variance	0.29150319
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=6)

Value	Count	Frequency (%)
1	10680	49.4%
2	8237	38.1%
1.5	1910	8.8%
3	612	2.8%
2.5	161	0.7%
3.5	8	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	10680	49.4%
1.5	1910	8.8%
2	8237	38.1%
2.5	161	0.7%
3	612	2.8%
3.5	8	< 0.1%

Value	Count	Frequency (%)
3.5	8	< 0.1%
3	612	2.8%
2.5	161	0.7%
2	8237	38.1%
1.5	1910	8.8%
1	10680	49.4%

waterfront
Categorical

HIGH CORRELATION IMBALANCE

Distinct	2
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	337.6 KiB

0	21445
1	163

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21608
Distinct characters	2
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	21445	99.2%
1	163	0.8%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	21445	99.2%
1	163	0.8%

Most occurring characters

Value	Count	Frequency (%)
0	21445	99.2%
1	163	0.8%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	21608	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	21445	99.2%
1	163	0.8%

Most occurring scripts

Value	Count	Frequency (%)
Common	21608	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	21445	99.2%
1	163	0.8%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	21608	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	21445	99.2%
1	163	0.8%

view
Categorical

HIGH CORRELATION IMBALANCE

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	337.6 KiB

0	19485
2	963
3	509
1	332
4	319

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21608
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	0
2nd row	0
3rd row	0
4th row	0
5th row	0

Common Values

Value	Count	Frequency (%)
0	19485	90.2%
2	963	4.5%
3	509	2.4%
1	332	1.5%
4	319	1.5%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
0	19485	90.2%
2	963	4.5%
3	509	2.4%
1	332	1.5%
4	319	1.5%

Most occurring characters

Value	Count	Frequency (%)
0	19485	90.2%
2	963	4.5%
3	509	2.4%
1	332	1.5%
4	319	1.5%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	21608	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
0	19485	90.2%
2	963	4.5%
3	509	2.4%
1	332	1.5%
4	319	1.5%

Most occurring scripts

Value	Count	Frequency (%)
Common	21608	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
0	19485	90.2%
2	963	4.5%
3	509	2.4%
1	332	1.5%
4	319	1.5%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	21608	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
0	19485	90.2%
2	963	4.5%
3	509	2.4%
1	332	1.5%
4	319	1.5%

condition
Categorical

Distinct	5
Distinct (%)	< 0.1%
Missing	0
Missing (%)	0.0%
Memory size	337.6 KiB

3	14027
4	5678
5	1701
2	172
1	30

Length

Max length	1
Median length	1
Mean length	1
Min length	1

Characters and Unicode

Total characters	21608
Distinct characters	5
Distinct categories	1 ?
Distinct scripts	1 ?
Distinct blocks	1 ?

The Unicode Standard assigns character properties to each code point, which can be used to analyse textual variables.

Unique

Unique	0 ?
Unique (%)	0.0%

Sample

1st row	3
2nd row	3
3rd row	3
4th row	5
5th row	3

Common Values

Value	Count	Frequency (%)
3	14027	64.9%
4	5678	26.3%
5	1701	7.9%
2	172	0.8%
1	30	0.1%

Length

Histogram of lengths of the category

Common Values (Plot)

Value	Count	Frequency (%)
3	14027	64.9%
4	5678	26.3%
5	1701	7.9%
2	172	0.8%
1	30	0.1%

Most occurring characters

Value	Count	Frequency (%)
3	14027	64.9%
4	5678	26.3%
5	1701	7.9%
2	172	0.8%
1	30	0.1%

Most occurring categories

Value	Count	Frequency (%)
Decimal Number	21608	100.0%

Most frequent character per category

Decimal Number

Value	Count	Frequency (%)
3	14027	64.9%
4	5678	26.3%
5	1701	7.9%
2	172	0.8%
1	30	0.1%

Most occurring scripts

Value	Count	Frequency (%)
Common	21608	100.0%

Most frequent character per script

Common

Value	Count	Frequency (%)
3	14027	64.9%
4	5678	26.3%
5	1701	7.9%
2	172	0.8%
1	30	0.1%

Most occurring blocks

Value	Count	Frequency (%)
ASCII	21608	100.0%

Most frequent character per block

ASCII

Value	Count	Frequency (%)
3	14027	64.9%
4	5678	26.3%
5	1701	7.9%
2	172	0.8%
1	30	0.1%

grade
Real number (ℝ)

HIGH CORRELATION

Distinct	12
Distinct (%)	0.1%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	7.6566549

Minimum	1
Maximum	13
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	337.6 KiB

Quantile statistics

Minimum	1
5-th percentile	6
Q1	7
median	7
Q3	8
95-th percentile	10
Maximum	13
Range	12
Interquartile range (IQR)	1

Descriptive statistics

Standard deviation	1.1754836
Coefficient of variation (CV)	0.15352443
Kurtosis	1.1918838
Mean	7.6566549
Median Absolute Deviation (MAD)	1
Skewness	0.7715804
Sum	165445
Variance	1.3817616
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=12)

Value	Count	Frequency (%)
7	8981	41.6%
8	6066	28.1%
9	2612	12.1%
6	2038	9.4%
10	1134	5.2%
11	399	1.8%
5	242	1.1%
12	90	0.4%
4	29	0.1%
13	13	0.1%
Other values (2)	4	< 0.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1	1	< 0.1%
3	3	< 0.1%
4	29	0.1%
5	242	1.1%
6	2038	9.4%
7	8981	41.6%
8	6066	28.1%
9	2612	12.1%
10	1134	5.2%
11	399	1.8%

Value	Count	Frequency (%)
13	13	0.1%
12	90	0.4%
11	399	1.8%
10	1134	5.2%
9	2612	12.1%
8	6066	28.1%
7	8981	41.6%
6	2038	9.4%
5	242	1.1%
4	29	0.1%

sqft_above
Real number (ℝ)

HIGH CORRELATION

Distinct	946
Distinct (%)	4.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1788.4148

Minimum	290
Maximum	9410
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	337.6 KiB

Quantile statistics

Minimum	290
5-th percentile	850
Q1	1190
median	1560
Q3	2210
95-th percentile	3400
Maximum	9410
Range	9120
Interquartile range (IQR)	1020

Descriptive statistics

Standard deviation	828.14115
Coefficient of variation (CV)	0.46305876
Kurtosis	3.4019277
Mean	1788.4148
Median Absolute Deviation (MAD)	450
Skewness	1.4467404
Sum	38644068
Variance	685817.77
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1300	212	1.0%
1010	210	1.0%
1200	206	1.0%
1220	192	0.9%
1140	184	0.9%
1400	180	0.8%
1060	178	0.8%
1180	177	0.8%
1340	176	0.8%
1250	174	0.8%
Other values (936)	19719	91.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
290	1	< 0.1%
370	1	< 0.1%
380	1	< 0.1%
384	1	< 0.1%
390	2	< 0.1%
410	1	< 0.1%
420	2	< 0.1%
430	1	< 0.1%
440	1	< 0.1%
460	1	< 0.1%

Value	Count	Frequency (%)
9410	1	< 0.1%
8860	1	< 0.1%
8570	1	< 0.1%
8020	1	< 0.1%
7880	1	< 0.1%
7850	1	< 0.1%
7680	1	< 0.1%
7420	1	< 0.1%
7320	1	< 0.1%
6720	1	< 0.1%

sqft_basement
Real number (ℝ)

ZEROS

Distinct	306
Distinct (%)	1.4%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	291.5441

Minimum	0
Maximum	4820
Zeros	13123
Zeros (%)	60.7%
Negative	0
Negative (%)	0.0%
Memory size	337.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	560
95-th percentile	1190
Maximum	4820
Range	4820
Interquartile range (IQR)	560

Descriptive statistics

Standard deviation	442.61256
Coefficient of variation (CV)	1.5181667
Kurtosis	2.7144328
Mean	291.5441
Median Absolute Deviation (MAD)	0
Skewness	1.5777307
Sum	6299685
Variance	195905.88
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	13123	60.7%
600	221	1.0%
700	218	1.0%
500	214	1.0%
800	206	1.0%
400	184	0.9%
1000	149	0.7%
900	144	0.7%
300	142	0.7%
200	108	0.5%
Other values (296)	6899	31.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	13123	60.7%
10	2	< 0.1%
20	1	< 0.1%
40	4	< 0.1%
50	11	0.1%
60	10	< 0.1%
65	1	< 0.1%
70	7	< 0.1%
80	20	0.1%
90	21	0.1%

Value	Count	Frequency (%)
4820	1	< 0.1%
4130	1	< 0.1%
3500	1	< 0.1%
3480	1	< 0.1%
3260	1	< 0.1%
3000	1	< 0.1%
2850	1	< 0.1%
2810	1	< 0.1%
2730	1	< 0.1%
2720	1	< 0.1%

yr_built
Real number (ℝ)

HIGH CORRELATION

Distinct	116
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1970.9999

Minimum	1900
Maximum	2015
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	337.6 KiB

Quantile statistics

Minimum	1900
5-th percentile	1915
Q1	1951
median	1975
Q3	1997
95-th percentile	2011
Maximum	2015
Range	115
Interquartile range (IQR)	46

Descriptive statistics

Standard deviation	29.371463
Coefficient of variation (CV)	0.014901808
Kurtosis	-0.65718074
Mean	1970.9999
Median Absolute Deviation (MAD)	23
Skewness	-0.46978236
Sum	42589366
Variance	862.68283
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2014	558	2.6%
2006	454	2.1%
2005	450	2.1%
2004	433	2.0%
2003	422	2.0%
2007	417	1.9%
1977	417	1.9%
1978	387	1.8%
1968	381	1.8%
2008	366	1.7%
Other values (106)	17323	80.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
1900	87	0.4%
1901	29	0.1%
1902	27	0.1%
1903	46	0.2%
1904	45	0.2%
1905	74	0.3%
1906	92	0.4%
1907	65	0.3%
1908	86	0.4%
1909	94	0.4%

Value	Count	Frequency (%)
2015	38	0.2%
2014	558	2.6%
2013	201	0.9%
2012	170	0.8%
2011	130	0.6%
2010	143	0.7%
2009	229	1.1%
2008	366	1.7%
2007	417	1.9%
2006	454	2.1%

yr_renovated
Real number (ℝ)

HIGH CORRELATION ZEROS

Distinct	70
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	84.330155

Minimum	0
Maximum	2015
Zeros	20695
Zeros (%)	95.8%
Negative	0
Negative (%)	0.0%
Memory size	337.6 KiB

Quantile statistics

Minimum	0
5-th percentile	0
Q1	0
median	0
Q3	0
95-th percentile	0
Maximum	2015
Range	2015
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	401.51703
Coefficient of variation (CV)	4.7612509
Kurtosis	18.721546
Mean	84.330155
Median Absolute Deviation (MAD)	0
Skewness	4.5517338
Sum	1822206
Variance	161215.92
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
0	20695	95.8%
2014	91	0.4%
2013	37	0.2%
2003	36	0.2%
2005	35	0.2%
2007	35	0.2%
2000	35	0.2%
2004	26	0.1%
1990	25	0.1%
2006	24	0.1%
Other values (60)	569	2.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	20695	95.8%
1934	1	< 0.1%
1940	2	< 0.1%
1944	1	< 0.1%
1945	3	< 0.1%
1946	2	< 0.1%
1948	1	< 0.1%
1950	2	< 0.1%
1951	1	< 0.1%
1953	3	< 0.1%

Value	Count	Frequency (%)
2015	16	0.1%
2014	91	0.4%
2013	37	0.2%
2012	11	0.1%
2011	13	0.1%
2010	18	0.1%
2009	22	0.1%
2008	18	0.1%
2007	35	0.2%
2006	24	0.1%

lat
Real number (ℝ)

Distinct	5034
Distinct (%)	23.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	47.56005

Minimum	47.1559
Maximum	47.7776
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	337.6 KiB

Quantile statistics

Minimum	47.1559
5-th percentile	47.3103
Q1	47.470875
median	47.5718
Q3	47.678
95-th percentile	47.749665
Maximum	47.7776
Range	0.6217
Interquartile range (IQR)	0.207125

Descriptive statistics

Standard deviation	0.13857802
Coefficient of variation (CV)	0.0029137484
Kurtosis	-0.67678345
Mean	47.56005
Median Absolute Deviation (MAD)	0.1049
Skewness	-0.4851826
Sum	1027677.6
Variance	0.019203867
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
47.5491	17	0.1%
47.6624	17	0.1%
47.5322	17	0.1%
47.6846	17	0.1%
47.6886	16	0.1%
47.6711	16	0.1%
47.6955	16	0.1%
47.6842	15	0.1%
47.5402	15	0.1%
47.6647	15	0.1%
Other values (5024)	21447	99.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
47.1559	1	< 0.1%
47.1593	1	< 0.1%
47.1622	1	< 0.1%
47.1647	1	< 0.1%
47.1764	1	< 0.1%
47.1775	1	< 0.1%
47.1776	2	< 0.1%
47.1795	1	< 0.1%
47.1803	1	< 0.1%
47.1808	1	< 0.1%

Value	Count	Frequency (%)
47.7776	3	< 0.1%
47.7775	3	< 0.1%
47.7774	1	< 0.1%
47.7772	3	< 0.1%
47.7771	2	< 0.1%
47.777	2	< 0.1%
47.7769	3	< 0.1%
47.7768	2	< 0.1%
47.7767	6	< 0.1%
47.7766	4	< 0.1%

long
Real number (ℝ)

Distinct	752
Distinct (%)	3.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	-122.21389

Minimum	-122.519
Maximum	-121.315
Zeros	0
Zeros (%)	0.0%
Negative	21608
Negative (%)	100.0%
Memory size	337.6 KiB

Quantile statistics

Minimum	-122.519
5-th percentile	-122.387
Q1	-122.328
median	-122.2305
Q3	-122.125
95-th percentile	-121.979
Maximum	-121.315
Range	1.204
Interquartile range (IQR)	0.203

Descriptive statistics

Standard deviation	0.14083016
Coefficient of variation (CV)	-0.0011523253
Kurtosis	1.0499275
Mean	-122.21389
Median Absolute Deviation (MAD)	0.1015
Skewness	0.88527684
Sum	-2640797.8
Variance	0.019833135
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
-122.29	116	0.5%
-122.3	111	0.5%
-122.362	104	0.5%
-122.291	100	0.5%
-122.363	99	0.5%
-122.372	99	0.5%
-122.288	98	0.5%
-122.284	95	0.4%
-122.357	95	0.4%
-122.365	94	0.4%
Other values (742)	20597	95.3%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-122.519	1	< 0.1%
-122.515	1	< 0.1%
-122.514	1	< 0.1%
-122.512	1	< 0.1%
-122.511	2	< 0.1%
-122.509	2	< 0.1%
-122.507	1	< 0.1%
-122.506	1	< 0.1%
-122.505	3	< 0.1%
-122.504	2	< 0.1%

Value	Count	Frequency (%)
-121.315	2	< 0.1%
-121.316	1	< 0.1%
-121.319	1	< 0.1%
-121.321	1	< 0.1%
-121.325	1	< 0.1%
-121.352	2	< 0.1%
-121.359	1	< 0.1%
-121.364	2	< 0.1%
-121.402	1	< 0.1%
-121.403	1	< 0.1%

sqft_living15
Real number (ℝ)

HIGH CORRELATION

Distinct	777
Distinct (%)	3.6%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1986.5832

Minimum	399
Maximum	6210
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	337.6 KiB

Quantile statistics

Minimum	399
5-th percentile	1140
Q1	1490
median	1840
Q3	2360
95-th percentile	3300
Maximum	6210
Range	5811
Interquartile range (IQR)	870

Descriptive statistics

Standard deviation	685.42147
Coefficient of variation (CV)	0.34502531
Kurtosis	1.5969742
Mean	1986.5832
Median Absolute Deviation (MAD)	410
Skewness	1.1082577
Sum	42926089
Variance	469802.6
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1540	197	0.9%
1440	195	0.9%
1560	192	0.9%
1500	181	0.8%
1460	169	0.8%
1580	167	0.8%
1610	166	0.8%
1720	166	0.8%
1800	166	0.8%
1620	165	0.8%
Other values (767)	19844	91.8%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
399	1	< 0.1%
460	2	< 0.1%
620	2	< 0.1%
670	1	< 0.1%
690	2	< 0.1%
700	2	< 0.1%
710	2	< 0.1%
720	2	< 0.1%
740	8	< 0.1%
750	3	< 0.1%

Value	Count	Frequency (%)
6210	1	< 0.1%
6110	1	< 0.1%
5790	6	< 0.1%
5610	1	< 0.1%
5600	1	< 0.1%
5500	1	< 0.1%
5380	1	< 0.1%
5340	1	< 0.1%
5330	1	< 0.1%
5220	1	< 0.1%

sqft_lot15
Real number (ℝ)

HIGH CORRELATION

Distinct	8689
Distinct (%)	40.2%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	12770.108

Minimum	651
Maximum	871200
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	337.6 KiB

Quantile statistics

Minimum	651
5-th percentile	2004.05
Q1	5100
median	7620
Q3	10083.25
95-th percentile	37065.8
Maximum	871200
Range	870549
Interquartile range (IQR)	4983.25

Descriptive statistics

Standard deviation	27307.007
Coefficient of variation (CV)	2.1383536
Kurtosis	150.73271
Mean	12770.108
Median Absolute Deviation (MAD)	2505
Skewness	9.505818
Sum	2.759365 × 10⁸
Variance	7.4567263 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
5000	427	2.0%
4000	357	1.7%
6000	289	1.3%
7200	211	1.0%
4800	145	0.7%
7500	142	0.7%
8400	116	0.5%
4500	111	0.5%
3600	111	0.5%
5100	109	0.5%
Other values (8679)	19590	90.7%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
651	1	< 0.1%
659	1	< 0.1%
660	1	< 0.1%
748	2	< 0.1%
750	4	< 0.1%
755	1	< 0.1%
757	1	< 0.1%
758	1	< 0.1%
788	1	< 0.1%
794	1	< 0.1%

Value	Count	Frequency (%)
871200	1	< 0.1%
858132	1	< 0.1%
560617	1	< 0.1%
438213	1	< 0.1%
434728	1	< 0.1%
425581	1	< 0.1%
422967	1	< 0.1%
411962	1	< 0.1%
392040	2	< 0.1%
386812	1	< 0.1%

age
Real number (ℝ)

HIGH CORRELATION

Distinct	116
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	44.000093

Minimum	0
Maximum	115
Zeros	38
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	337.6 KiB

Quantile statistics

Minimum	0
5-th percentile	4
Q1	18
median	40
Q3	64
95-th percentile	100
Maximum	115
Range	115
Interquartile range (IQR)	46

Descriptive statistics

Standard deviation	29.371463
Coefficient of variation (CV)	0.66753184
Kurtosis	-0.65718074
Mean	44.000093
Median Absolute Deviation (MAD)	23
Skewness	0.46978236
Sum	950754
Variance	862.68283
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
1	558	2.6%
9	454	2.1%
10	450	2.1%
11	433	2.0%
12	422	2.0%
8	417	1.9%
38	417	1.9%
37	387	1.8%
47	381	1.8%
7	366	1.7%
Other values (106)	17323	80.2%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	38	0.2%
1	558	2.6%
2	201	0.9%
3	170	0.8%
4	130	0.6%
5	143	0.7%
6	229	1.1%
7	366	1.7%
8	417	1.9%
9	454	2.1%

Value	Count	Frequency (%)
115	87	0.4%
114	29	0.1%
113	27	0.1%
112	46	0.2%
111	45	0.2%
110	74	0.3%
109	92	0.4%
108	65	0.3%
107	86	0.4%
106	94	0.4%

renovation_age
Real number (ℝ)

HIGH CORRELATION

Distinct	70
Distinct (%)	0.3%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	1930.6698

Minimum	0
Maximum	2015
Zeros	16
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	337.6 KiB

Quantile statistics

Minimum	0
5-th percentile	2015
Q1	2015
median	2015
Q3	2015
95-th percentile	2015
Maximum	2015
Range	2015
Interquartile range (IQR)	0

Descriptive statistics

Standard deviation	401.51703
Coefficient of variation (CV)	0.20796773
Kurtosis	18.721546
Mean	1930.6698
Median Absolute Deviation (MAD)	0
Skewness	-4.5517338
Sum	41717914
Variance	161215.92
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
2015	20695	95.8%
1	91	0.4%
2	37	0.2%
12	36	0.2%
10	35	0.2%
8	35	0.2%
15	35	0.2%
11	26	0.1%
25	25	0.1%
9	24	0.1%
Other values (60)	569	2.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	16	0.1%
1	91	0.4%
2	37	0.2%
3	11	0.1%
4	13	0.1%
5	18	0.1%
6	22	0.1%
7	18	0.1%
8	35	0.2%
9	24	0.1%

Value	Count	Frequency (%)
2015	20695	95.8%
81	1	< 0.1%
75	2	< 0.1%
71	1	< 0.1%
70	3	< 0.1%
69	2	< 0.1%
67	1	< 0.1%
65	2	< 0.1%
64	1	< 0.1%
62	3	< 0.1%

Auto

Heatmap
Table

	age	bathrooms	bedrooms	condition	floors	grade	lat	long	price	renovation_age	sqft_above	sqft_basement	sqft_living	sqft_living15	sqft_lot	sqft_lot15	view	waterfront	yr_built	yr_renovated
age	1.000	-0.567	-0.180	0.248	-0.552	-0.501	0.126	-0.413	-0.102	-0.214	-0.472	0.178	-0.353	-0.336	0.037	0.016	0.042	0.034	-1.000	0.214
bathrooms	-0.567	1.000	0.522	0.130	0.547	0.658	0.008	0.262	0.497	-0.043	0.691	0.192	0.746	0.570	0.069	0.063	0.114	0.102	0.567	0.043
bedrooms	-0.180	0.522	1.000	0.024	0.228	0.381	-0.021	0.191	0.345	-0.017	0.540	0.231	0.647	0.444	0.216	0.201	0.038	0.000	0.180	0.017
condition	0.248	0.130	0.024	1.000	-0.288	-0.167	-0.022	-0.085	0.018	0.066	-0.158	0.162	-0.063	-0.087	0.115	0.118	0.025	0.017	-0.394	-0.066
floors	-0.552	0.547	0.228	-0.288	1.000	0.502	0.025	0.149	0.322	-0.012	0.599	-0.272	0.401	0.306	-0.234	-0.231	0.024	0.022	0.552	0.012
grade	-0.501	0.658	0.381	-0.167	0.502	1.000	0.104	0.223	0.658	-0.016	0.712	0.093	0.717	0.663	0.152	0.156	0.143	0.118	0.501	0.016
lat	0.126	0.008	-0.021	-0.022	0.025	0.104	1.000	-0.143	0.456	-0.025	-0.026	0.116	0.031	0.028	-0.122	-0.117	0.068	0.034	-0.126	0.025
long	-0.413	0.262	0.191	-0.085	0.149	0.223	-0.143	1.000	0.063	0.075	0.385	-0.200	0.284	0.380	0.371	0.373	0.085	0.097	0.413	-0.075
price	-0.102	0.497	0.345	0.018	0.322	0.658	0.456	0.063	1.000	-0.102	0.542	0.252	0.644	0.572	0.075	0.063	0.208	0.320	0.102	0.102
renovation_age	-0.214	-0.043	-0.017	0.066	-0.012	-0.016	-0.025	0.075	-0.102	1.000	-0.031	-0.063	-0.053	0.006	-0.008	-0.009	0.108	0.092	0.214	-1.000
sqft_above	-0.472	0.691	0.540	-0.158	0.599	0.712	-0.026	0.385	0.542	-0.031	1.000	-0.166	0.843	0.697	0.272	0.254	0.089	0.083	0.472	0.031
sqft_basement	0.178	0.192	0.231	0.162	-0.272	0.093	0.116	-0.200	0.252	-0.063	-0.166	1.000	0.328	0.130	0.037	0.030	0.159	0.134	-0.178	0.063
sqft_living	-0.353	0.746	0.647	-0.063	0.401	0.717	0.031	0.284	0.644	-0.053	0.843	0.328	1.000	0.747	0.304	0.284	0.149	0.140	0.353	0.053
sqft_living15	-0.336	0.570	0.444	-0.087	0.306	0.663	0.028	0.380	0.572	0.006	0.697	0.130	0.747	1.000	0.360	0.366	0.147	0.089	0.336	-0.006
sqft_lot	0.037	0.069	0.216	0.115	-0.234	0.152	-0.122	0.371	0.075	-0.008	0.272	0.037	0.304	0.360	1.000	0.922	0.040	0.014	-0.037	0.008
sqft_lot15	0.016	0.063	0.201	0.118	-0.231	0.156	-0.117	0.373	0.063	-0.009	0.254	0.030	0.284	0.366	0.922	1.000	0.035	0.000	-0.016	0.009
view	0.042	0.114	0.038	0.025	0.024	0.143	0.068	0.085	0.208	0.108	0.089	0.159	0.149	0.147	0.040	0.035	1.000	0.592	-0.066	0.096
waterfront	0.034	0.102	0.000	0.017	0.022	0.118	0.034	0.097	0.320	0.092	0.083	0.134	0.140	0.089	0.014	0.000	0.592	1.000	-0.029	0.092
yr_built	-1.000	0.567	0.180	-0.394	0.552	0.501	-0.126	0.413	0.102	0.214	0.472	-0.178	0.353	0.336	-0.037	-0.016	-0.066	-0.029	1.000	-0.214
yr_renovated	0.214	0.043	0.017	-0.066	0.012	0.016	0.025	-0.075	0.102	-1.000	0.031	0.063	0.053	-0.006	0.008	0.009	0.096	0.092	-0.214	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	condition	grade	sqft_above	sqft_basement	yr_built	yr_renovated	lat	long	sqft_living15	sqft_lot15	age	renovation_age
0	221900.0	3	1.00	1180	5650	1.0	3	7	1180	0	1955	0	47.5112	-122.257	1340	5650	60	2015
1	538000.0	3	2.25	2570	7242	2.0	3	7	2170	400	1951	1991	47.7210	-122.319	1690	7639	64	24
2	180000.0	2	1.00	770	10000	1.0	3	6	770	0	1933	0	47.7379	-122.233	2720	8062	82	2015
3	604000.0	4	3.00	1960	5000	1.0	5	7	1050	910	1965	0	47.5208	-122.393	1360	5000	50	2015
4	510000.0	3	2.00	1680	8080	1.0	3	8	1680	0	1987	0	47.6168	-122.045	1800	7503	28	2015
5	1225000.0	4	4.50	5420	101930	1.0	3	11	3890	1530	2001	0	47.6561	-122.005	4760	101930	14	2015
6	257500.0	3	2.25	1715	6819	2.0	3	7	1715	0	1995	0	47.3097	-122.327	2238	6819	20	2015
7	291850.0	3	1.50	1060	9711	1.0	3	7	1060	0	1963	0	47.4095	-122.315	1650	9711	52	2015
8	229500.0	3	1.00	1780	7470	1.0	3	7	1050	730	1960	0	47.5123	-122.337	1780	8113	55	2015
9	323000.0	3	2.50	1890	6560	2.0	3	7	1890	0	2003	0	47.3684	-122.031	2390	7570	12	2015

	price	bedrooms	bathrooms	sqft_living	sqft_lot	floors	condition	grade	sqft_above	sqft_basement	yr_built	lat	long	sqft_living15	sqft_lot15	age	renovation_age
21603	507250.0	3	2.50	2270	5536	2.0	3	8	2270	0	2003	47.5389	-121.881	2270	5731	12	2015
21604	429000.0	3	2.00	1490	1126	3.0	3	8	1490	0	2014	47.5699	-122.288	1400	1230	1	2015
21605	610685.0	4	2.50	2520	6023	2.0	3	9	2520	0	2014	47.5137	-122.167	2520	6023	1	2015
21606	1007500.0	4	3.50	3510	7200	2.0	3	9	2600	910	2009	47.5537	-122.398	2050	6200	6	2015
21607	475000.0	3	2.50	1310	1294	2.0	3	8	1180	130	2008	47.5773	-122.409	1330	1265	7	2015
21608	360000.0	3	2.50	1530	1131	3.0	3	8	1530	0	2009	47.6993	-122.346	1530	1509	6	2015
21609	400000.0	4	2.50	2310	5813	2.0	3	8	2310	0	2014	47.5107	-122.362	1830	7200	1	2015
21610	402101.0	2	0.75	1020	1350	2.0	3	7	1020	0	2009	47.5944	-122.299	1020	2007	6	2015
21611	400000.0	3	2.50	1600	2388	2.0	3	8	1600	0	2004	47.5345	-122.069	1410	1287	11	2015
21612	325000.0	2	0.75	1020	1076	2.0	3	7	1020	0	2008	47.5941	-122.299	1020	1357	7	2015

Overview

Variables

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Common Values

Length

Common Values (Plot)

Most occurring characters

Most occurring categories

Most frequent character per category

Decimal Number

Most occurring scripts

Most frequent character per script

Common

Most occurring blocks

Most frequent character per block

ASCII

Interactions

Correlations

Missing values

Sample